2014-11-07 - 12560.400 - Spec - Regional Reporting-Queries and Reports #CrystalReportDevelopment
SPECIFICATION
12560.400 - Regional Reporting - Queries and Reports
Requirement Summary
Need to create queries, transports and reports based off of list sent previously for regional reporting.
Admin Info
Purpose
|
Need to create queries, transports and reports based off of list sent previously for regional reporting.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Naga Ramineni
|
Spec Created Date
|
11/07/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
Attached Document reports
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
20
|
2
|
Documentation
|
30
|
3
|
Development/ Config
|
80
|
4
|
Unit test in DEV
|
20
|
5
|
Unit test in QUA
|
10
|
6
|
Other activity
|
40
|
|
TOTAL
|
200
|
References
Prior Tickets
None
Documents
Regional Master Reports List.xlsx
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Change the report data sources from normal queries to Regional Queries and filter the report data Regionwise.
Solution Summary
1. Create Regional queries based on Multi-provider in BW using region filter.
2. Create Transports to move the BEx queries.
3. Change data sources from normal queries to Regional queries.
4. Need to change the formulas, if any formulas are having issues.
5. Need to remove repository functions from the report.
6. Change descriptions & font style for Japan regional reports.
7. Modify Currency symbols for the report depending on region.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Solution Details
1. Create Regional queries based on Multi-provider in BW using region filter.
2. Create Transports to move the BEx queries from BPD to BPP.
3. Change data sources from normal Queries to Regional Queries in crystal designer.
4. Need to change the formulas, if any formula are having issues.
5. Need to remove repository functions from the report.
6. Change descriptions & font style for Japan regional reports.
7. Modify Currency symbols for the report measures depending on region and currency used.
Issues
None